/**
* @描述: HcChrgClientExample.java
* @作者: fangtao
* @公司 浙江鸿程计算机系统有限公司
* @创建日期: 2020-10-26 09:33:20
*/
package com.hcss.sys.client.model;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class HcChrgClientExample {
    /**
     * HC_CHRG_CLIENT
     */
    protected String orderByClause;
    
    /**
     * HC_CHRG_CLIENT
     */
    protected boolean distinct;
    
    /**
     * HC_CHRG_CLIENT
     */
    protected List<Criteria> oredCriteria;
    
    /**
     * HC_CHRG_CLIENT
     */
    protected String groupBy;

    /**
     *  构造查询条件
     */
    public HcChrgClientExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     *  设置排序字段
     *
     * @param orderByClause 排序字段
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     *  获取排序字段
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     *  设置过滤重复数据
     *
     * @param distinct 是否过滤重复数据
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     *  是否过滤重复数据
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     *  获取当前的查询条件实例
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *  新增一个查询条件
     *
     * @param criteria 过滤条件实例
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *  新增一个查询条件
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     *  创建一个查询条件
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     *  内部构建查询条件对象
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     *  清除查询条件
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     *  设置分组字段
     *
     * @param groupBy
     */
    public void setGroupBy(String groupBy) {
        this.groupBy=groupBy;
    }

    /**
     *  获取分组字段
     */
    public String getGroupBy() {
        return groupBy;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCFullnameIsNull() {
            addCriterion("C_FULLNAME is null");
            return (Criteria) this;
        }

        public Criteria andCFullnameIsNotNull() {
            addCriterion("C_FULLNAME is not null");
            return (Criteria) this;
        }

        public Criteria andCFullnameEqualTo(String value) {
            addCriterion("C_FULLNAME =", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameNotEqualTo(String value) {
            addCriterion("C_FULLNAME <>", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameGreaterThan(String value) {
            addCriterion("C_FULLNAME >", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameGreaterThanOrEqualTo(String value) {
            addCriterion("C_FULLNAME >=", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameLessThan(String value) {
            addCriterion("C_FULLNAME <", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameLessThanOrEqualTo(String value) {
            addCriterion("C_FULLNAME <=", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameLike(String value) {
            addCriterion("C_FULLNAME like", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameNotLike(String value) {
            addCriterion("C_FULLNAME not like", value, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameIn(List<String> values) {
            addCriterion("C_FULLNAME in", values, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameNotIn(List<String> values) {
            addCriterion("C_FULLNAME not in", values, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameBetween(String value1, String value2) {
            addCriterion("C_FULLNAME between", value1, value2, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCFullnameNotBetween(String value1, String value2) {
            addCriterion("C_FULLNAME not between", value1, value2, "cFullname");
            return (Criteria) this;
        }

        public Criteria andCShortnameIsNull() {
            addCriterion("C_SHORTNAME is null");
            return (Criteria) this;
        }

        public Criteria andCShortnameIsNotNull() {
            addCriterion("C_SHORTNAME is not null");
            return (Criteria) this;
        }

        public Criteria andCShortnameEqualTo(String value) {
            addCriterion("C_SHORTNAME =", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameNotEqualTo(String value) {
            addCriterion("C_SHORTNAME <>", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameGreaterThan(String value) {
            addCriterion("C_SHORTNAME >", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameGreaterThanOrEqualTo(String value) {
            addCriterion("C_SHORTNAME >=", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameLessThan(String value) {
            addCriterion("C_SHORTNAME <", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameLessThanOrEqualTo(String value) {
            addCriterion("C_SHORTNAME <=", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameLike(String value) {
            addCriterion("C_SHORTNAME like", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameNotLike(String value) {
            addCriterion("C_SHORTNAME not like", value, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameIn(List<String> values) {
            addCriterion("C_SHORTNAME in", values, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameNotIn(List<String> values) {
            addCriterion("C_SHORTNAME not in", values, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameBetween(String value1, String value2) {
            addCriterion("C_SHORTNAME between", value1, value2, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCShortnameNotBetween(String value1, String value2) {
            addCriterion("C_SHORTNAME not between", value1, value2, "cShortname");
            return (Criteria) this;
        }

        public Criteria andCLinkmanIsNull() {
            addCriterion("C_LINKMAN is null");
            return (Criteria) this;
        }

        public Criteria andCLinkmanIsNotNull() {
            addCriterion("C_LINKMAN is not null");
            return (Criteria) this;
        }

        public Criteria andCLinkmanEqualTo(String value) {
            addCriterion("C_LINKMAN =", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanNotEqualTo(String value) {
            addCriterion("C_LINKMAN <>", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanGreaterThan(String value) {
            addCriterion("C_LINKMAN >", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanGreaterThanOrEqualTo(String value) {
            addCriterion("C_LINKMAN >=", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanLessThan(String value) {
            addCriterion("C_LINKMAN <", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanLessThanOrEqualTo(String value) {
            addCriterion("C_LINKMAN <=", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanLike(String value) {
            addCriterion("C_LINKMAN like", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanNotLike(String value) {
            addCriterion("C_LINKMAN not like", value, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanIn(List<String> values) {
            addCriterion("C_LINKMAN in", values, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanNotIn(List<String> values) {
            addCriterion("C_LINKMAN not in", values, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanBetween(String value1, String value2) {
            addCriterion("C_LINKMAN between", value1, value2, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCLinkmanNotBetween(String value1, String value2) {
            addCriterion("C_LINKMAN not between", value1, value2, "cLinkman");
            return (Criteria) this;
        }

        public Criteria andCTeleIsNull() {
            addCriterion("C_TELE is null");
            return (Criteria) this;
        }

        public Criteria andCTeleIsNotNull() {
            addCriterion("C_TELE is not null");
            return (Criteria) this;
        }

        public Criteria andCTeleEqualTo(String value) {
            addCriterion("C_TELE =", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleNotEqualTo(String value) {
            addCriterion("C_TELE <>", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleGreaterThan(String value) {
            addCriterion("C_TELE >", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleGreaterThanOrEqualTo(String value) {
            addCriterion("C_TELE >=", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleLessThan(String value) {
            addCriterion("C_TELE <", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleLessThanOrEqualTo(String value) {
            addCriterion("C_TELE <=", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleLike(String value) {
            addCriterion("C_TELE like", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleNotLike(String value) {
            addCriterion("C_TELE not like", value, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleIn(List<String> values) {
            addCriterion("C_TELE in", values, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleNotIn(List<String> values) {
            addCriterion("C_TELE not in", values, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleBetween(String value1, String value2) {
            addCriterion("C_TELE between", value1, value2, "cTele");
            return (Criteria) this;
        }

        public Criteria andCTeleNotBetween(String value1, String value2) {
            addCriterion("C_TELE not between", value1, value2, "cTele");
            return (Criteria) this;
        }

        public Criteria andOpIdIsNull() {
            addCriterion("OP_ID is null");
            return (Criteria) this;
        }

        public Criteria andOpIdIsNotNull() {
            addCriterion("OP_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOpIdEqualTo(String value) {
            addCriterion("OP_ID =", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdNotEqualTo(String value) {
            addCriterion("OP_ID <>", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdGreaterThan(String value) {
            addCriterion("OP_ID >", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdGreaterThanOrEqualTo(String value) {
            addCriterion("OP_ID >=", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdLessThan(String value) {
            addCriterion("OP_ID <", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdLessThanOrEqualTo(String value) {
            addCriterion("OP_ID <=", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdLike(String value) {
            addCriterion("OP_ID like", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdNotLike(String value) {
            addCriterion("OP_ID not like", value, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdIn(List<String> values) {
            addCriterion("OP_ID in", values, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdNotIn(List<String> values) {
            addCriterion("OP_ID not in", values, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdBetween(String value1, String value2) {
            addCriterion("OP_ID between", value1, value2, "opId");
            return (Criteria) this;
        }

        public Criteria andOpIdNotBetween(String value1, String value2) {
            addCriterion("OP_ID not between", value1, value2, "opId");
            return (Criteria) this;
        }

        public Criteria andOpDateIsNull() {
            addCriterion("OP_DATE is null");
            return (Criteria) this;
        }

        public Criteria andOpDateIsNotNull() {
            addCriterion("OP_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andOpDateEqualTo(Date value) {
            addCriterion("OP_DATE =", value, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateNotEqualTo(Date value) {
            addCriterion("OP_DATE <>", value, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateGreaterThan(Date value) {
            addCriterion("OP_DATE >", value, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateGreaterThanOrEqualTo(Date value) {
            addCriterion("OP_DATE >=", value, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateLessThan(Date value) {
            addCriterion("OP_DATE <", value, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateLessThanOrEqualTo(Date value) {
            addCriterion("OP_DATE <=", value, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateIn(List<Date> values) {
            addCriterion("OP_DATE in", values, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateNotIn(List<Date> values) {
            addCriterion("OP_DATE not in", values, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateBetween(Date value1, Date value2) {
            addCriterion("OP_DATE between", value1, value2, "opDate");
            return (Criteria) this;
        }

        public Criteria andOpDateNotBetween(Date value1, Date value2) {
            addCriterion("OP_DATE not between", value1, value2, "opDate");
            return (Criteria) this;
        }

        public Criteria andClientStatusIsNull() {
            addCriterion("CLIENT_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andClientStatusIsNotNull() {
            addCriterion("CLIENT_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andClientStatusEqualTo(String value) {
            addCriterion("CLIENT_STATUS =", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusNotEqualTo(String value) {
            addCriterion("CLIENT_STATUS <>", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusGreaterThan(String value) {
            addCriterion("CLIENT_STATUS >", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_STATUS >=", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusLessThan(String value) {
            addCriterion("CLIENT_STATUS <", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_STATUS <=", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusLike(String value) {
            addCriterion("CLIENT_STATUS like", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusNotLike(String value) {
            addCriterion("CLIENT_STATUS not like", value, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusIn(List<String> values) {
            addCriterion("CLIENT_STATUS in", values, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusNotIn(List<String> values) {
            addCriterion("CLIENT_STATUS not in", values, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusBetween(String value1, String value2) {
            addCriterion("CLIENT_STATUS between", value1, value2, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientStatusNotBetween(String value1, String value2) {
            addCriterion("CLIENT_STATUS not between", value1, value2, "clientStatus");
            return (Criteria) this;
        }

        public Criteria andClientTypeIsNull() {
            addCriterion("CLIENT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andClientTypeIsNotNull() {
            addCriterion("CLIENT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andClientTypeEqualTo(String value) {
            addCriterion("CLIENT_TYPE =", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeNotEqualTo(String value) {
            addCriterion("CLIENT_TYPE <>", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeGreaterThan(String value) {
            addCriterion("CLIENT_TYPE >", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_TYPE >=", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeLessThan(String value) {
            addCriterion("CLIENT_TYPE <", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_TYPE <=", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeLike(String value) {
            addCriterion("CLIENT_TYPE like", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeNotLike(String value) {
            addCriterion("CLIENT_TYPE not like", value, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeIn(List<String> values) {
            addCriterion("CLIENT_TYPE in", values, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeNotIn(List<String> values) {
            addCriterion("CLIENT_TYPE not in", values, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeBetween(String value1, String value2) {
            addCriterion("CLIENT_TYPE between", value1, value2, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientTypeNotBetween(String value1, String value2) {
            addCriterion("CLIENT_TYPE not between", value1, value2, "clientType");
            return (Criteria) this;
        }

        public Criteria andClientRemarkIsNull() {
            addCriterion("CLIENT_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andClientRemarkIsNotNull() {
            addCriterion("CLIENT_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andClientRemarkEqualTo(String value) {
            addCriterion("CLIENT_REMARK =", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkNotEqualTo(String value) {
            addCriterion("CLIENT_REMARK <>", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkGreaterThan(String value) {
            addCriterion("CLIENT_REMARK >", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_REMARK >=", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkLessThan(String value) {
            addCriterion("CLIENT_REMARK <", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_REMARK <=", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkLike(String value) {
            addCriterion("CLIENT_REMARK like", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkNotLike(String value) {
            addCriterion("CLIENT_REMARK not like", value, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkIn(List<String> values) {
            addCriterion("CLIENT_REMARK in", values, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkNotIn(List<String> values) {
            addCriterion("CLIENT_REMARK not in", values, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkBetween(String value1, String value2) {
            addCriterion("CLIENT_REMARK between", value1, value2, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientRemarkNotBetween(String value1, String value2) {
            addCriterion("CLIENT_REMARK not between", value1, value2, "clientRemark");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusIsNull() {
            addCriterion("CLIENT_NCSTATUS is null");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusIsNotNull() {
            addCriterion("CLIENT_NCSTATUS is not null");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusEqualTo(String value) {
            addCriterion("CLIENT_NCSTATUS =", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusNotEqualTo(String value) {
            addCriterion("CLIENT_NCSTATUS <>", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusGreaterThan(String value) {
            addCriterion("CLIENT_NCSTATUS >", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_NCSTATUS >=", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusLessThan(String value) {
            addCriterion("CLIENT_NCSTATUS <", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_NCSTATUS <=", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusLike(String value) {
            addCriterion("CLIENT_NCSTATUS like", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusNotLike(String value) {
            addCriterion("CLIENT_NCSTATUS not like", value, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusIn(List<String> values) {
            addCriterion("CLIENT_NCSTATUS in", values, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusNotIn(List<String> values) {
            addCriterion("CLIENT_NCSTATUS not in", values, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusBetween(String value1, String value2) {
            addCriterion("CLIENT_NCSTATUS between", value1, value2, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcstatusNotBetween(String value1, String value2) {
            addCriterion("CLIENT_NCSTATUS not between", value1, value2, "clientNcstatus");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkIsNull() {
            addCriterion("CLIENT_NCREMARK is null");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkIsNotNull() {
            addCriterion("CLIENT_NCREMARK is not null");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkEqualTo(String value) {
            addCriterion("CLIENT_NCREMARK =", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkNotEqualTo(String value) {
            addCriterion("CLIENT_NCREMARK <>", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkGreaterThan(String value) {
            addCriterion("CLIENT_NCREMARK >", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkGreaterThanOrEqualTo(String value) {
            addCriterion("CLIENT_NCREMARK >=", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkLessThan(String value) {
            addCriterion("CLIENT_NCREMARK <", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkLessThanOrEqualTo(String value) {
            addCriterion("CLIENT_NCREMARK <=", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkLike(String value) {
            addCriterion("CLIENT_NCREMARK like", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkNotLike(String value) {
            addCriterion("CLIENT_NCREMARK not like", value, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkIn(List<String> values) {
            addCriterion("CLIENT_NCREMARK in", values, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkNotIn(List<String> values) {
            addCriterion("CLIENT_NCREMARK not in", values, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkBetween(String value1, String value2) {
            addCriterion("CLIENT_NCREMARK between", value1, value2, "clientNcremark");
            return (Criteria) this;
        }

        public Criteria andClientNcremarkNotBetween(String value1, String value2) {
            addCriterion("CLIENT_NCREMARK not between", value1, value2, "clientNcremark");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private final String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private final String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}